-- @owner: songjing20
-- @date: 2024-7-12
-- @testpoint: DQL语法：结合connect by子句

--step1:建表;except:成功
drop table if exists t_connect_047;
create table t_connect_047(id int, lid int, name text);

--step2:插入数据;except:成功
insert into t_connect_047 values(1,null,'A'),(2,1,'B'),(3,2,'C');

--step3:结合connect by子句;except:成功
select * from t_connect_047 connect by id=lid;
select * from t_connect_047 connect by prior id=lid;

--step4:清理环境;except:成功
drop table t_connect_047;
